package com.study.mybatis.mapper;

import java.util.List;

import com.study.mybatis.po.OrderCustom;
import com.study.mybatis.po.Orders;
import com.study.mybatis.po.User;

public interface OrdersMapperCustom {
	
	//一对一查询，查询订单关联用户信息，resultType
	public List<OrderCustom> findOrderUserListResultType() throws Exception;
	//一对一查询，查询订单关联用户信息，resultMap
	public List<Orders> findOrderUserListResultMap() throws Exception;
	//一对多查询，查询订单及订单详情，resultMap
	public List<Orders> findOrderAndOrderDetailsResultMap() throws Exception;
	//一对多查询，查询所有用户信息，关联查询订单及订单明细信息及商品信息，订单明细信息中关联查询商品信息，resultMap
	public List<User> findUserOrderDetailsResultMap() throws Exception;
}
